
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE proc [dbo].[updateHotelInfo]
(
	@HotelID int, --1
	@HotelName nvarchar (200), --3
	@Price money,--2	
	@ProvinceID int,--4
	@RangeID int,	--5
	@ServiceID int,--6
	@TotalRoom int,--7
	@Images nvarchar (200),--8
	@Description nvarchar (2000), --9
	@Address1 nvarchar (200),--10
	@Email nvarchar (50),--11
	@Phone1 nvarchar (50),--12
	@Fax nvarchar (50),--13
	@Phone2 nvarchar (50),--14
	@Address2 nvarchar (200),--15
	@Address3 nvarchar (200)--16
)
as 
Update Hotels
set  HotelName = @HotelName,
	 Prices = @Price,
	 ProvinceID = @ProvinceID,
	 RangeID = @RangeID,
	 ServicesID = @ServiceID,
	 TotalRoom = @TotalRoom,
	 Images = @Images,
	 Description = @Description,
	 Address1 = @Address1,
	 Email	= @Email,
	 Phone1 = @Phone1,
	 Fax = @Fax,
	 Phone2 = @Phone2,
	 Address2 = @Address2,
	 Address3 = @Address3 
Where ID = @HotelID
GO
